Mega Code Archive
Comparison Functions Operators
1) Check to see if the first name is NULL
2) Compare string value using the Greater than ( = ) operator
3) Compare string value using the Greater than or equal( = )
4) Compare string value using the Less than or equal(=) operator
5) Compare string value using the Less than( ) operator
6) Compare string value using the Not equal operator
7) Comparing integer value with less than operator
8) Comparison Functions and Operators
9) Data type conversion in Not equal operator
10) Equal
11) Expr BETWEEN min AND max
12) Expr IN (value, )
13) Greater than
14) Greater than or equal
15) GREATEST(@id1, @id2, @id3, @id4, @id5)
16) GREATEST(value1,value2, ) returns NULL if any argument is NULL
17) GREATEST(value1,value2, ) returns the largest (maximum-valued) argument within two or more arguments
18) INTERVAL(N,N1,N2,N3, )
19) IS boolean_value
20) IS NOT boolean_value
21) IS NOT NULL
22) IS NULL
23) ISNULL(expr)
24) LEAST with float value
25) LEAST() returns NULL if any argument is NULL
26) LEAST(value1,value2, ) returns the smallest (minimum-valued) argument withing two or more arguments
27) Less than
28) Less than or equal
29) Not equal
30) NULL-safe equal
31) SELECT 0 0 = 0
32) SELECT 0 01 = 0
33) SELECT 01 0 01
34) SELECT 2 BETWEEN 2 AND 3
35) SELECT 2 BETWEEN 2 AND x-3
36) SELECT A IN (A,B,C)
37) SELECT b BETWEEN a AND c
38) SELECT COALESCE(NULL,NULL,NULL)
39) SELECT GREATEST(3 0,3 0,5 0,7 0)
40) SELECT GREATEST(B,A,C)
41) SELECT ISNULL(10)
42) String comparisons are not case sensitive
43) Type conversion when using the Equal operator
44) Use GREATEST(value1,value2, ) function with column data
45) Use IN with data in a table
46) Use LEAST with data in a table
47) Using IN with subquery
48) Using ISNULL in where clause
49) Using ISNULL with data in a table
50) Using LEAST with string value
51) Using more than one column with a NOT IN operator
52) You should never mix quoted and unquoted values in an IN list